CREATE TABLE [dbo].[Perspective]
(
[PerspectiveKey] [uniqueidentifier] NOT NULL,
[PerspectiveName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebsiteKey] [uniqueidentifier] NOT NULL,
[RootHierarchyKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL,
[HomePageHierarchyKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Perspective] ADD CONSTRAINT [PK_Perspective] PRIMARY KEY CLUSTERED ([PerspectiveKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Perspective] ADD CONSTRAINT [AK_Perspective_PerspectiveName] UNIQUE NONCLUSTERED ([PerspectiveName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Perspective_HomePageHierarchyKey] ON [dbo].[Perspective] ([HomePageHierarchyKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Perspective_RootHierarchyKey] ON [dbo].[Perspective] ([RootHierarchyKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Perspective] ADD CONSTRAINT [FK_Perspective_Hierarchy] FOREIGN KEY ([RootHierarchyKey]) REFERENCES [dbo].[Hierarchy] ([HierarchyKey])
GO
ALTER TABLE [dbo].[Perspective] ADD CONSTRAINT [FK_Perspective_Hierarchy_HomePage] FOREIGN KEY ([HomePageHierarchyKey]) REFERENCES [dbo].[Hierarchy] ([HierarchyKey])
GO
ALTER TABLE [dbo].[Perspective] ADD CONSTRAINT [FK_Perspective_HierarchyRoot] FOREIGN KEY ([RootHierarchyKey]) REFERENCES [dbo].[HierarchyRoot] ([RootHierarchyKey])
GO